update [EntityRevisions]
set IsLatestCompletedRevision = 0, IsLatestRevision=0
where EntityTypeParameter like 'Content1%'
INSERT INTO [dbo].[EntityRevisions]
       ([EntityId]
       ,[EntityTypeParameter]
       ,[IsLatestRevision]
       ,[IsLatestCompletedRevision]
       ,[IsDeleted]
       ,[WorkflowId]
       ,[PublishStartDate]
       ,[PublishEndDate]
       ,[IsPublished]
       ,[PublicEntityId])
     
select ContentId,'Content'+CAST(ContentTypeId as nvarchar(50)),1,1,0,null,null,null,1,PublicContentId
from Contents
where ContentTypeId not in (select contenttypeid from ContentTypes where ContentTypeName='page-content')
go